CREATE TABLE [dbo].[TTVEHI]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[NU_PLAC] [dbo].[TD_VC_200] NOT NULL,
[DE_MARC] [dbo].[TD_VC_050] NOT NULL,
[DE_MODE] [dbo].[TD_VC_050] NOT NULL,
[NU_ANNO_VEHI] [dbo].[TD_IN_004_ANOS] NULL,
[DE_COMB] [dbo].[TD_VC_050] NULL,
[DE_OBSE] [dbo].[TD_VC_100] NULL,
[NU_KILO_INIC] [dbo].[TD_VC_010] NULL,
[NU_KILO_ACTU] [dbo].[TD_VC_010] NULL,
[NU_SERI_MOTO] [dbo].[TD_VC_020] NULL,
[NU_SERI_VEHI] [dbo].[TD_VC_020] NULL,
[NU_TARJ_PROP] [dbo].[TD_VC_020] NULL,
[DE_TITU_TAPR] [dbo].[TD_VC_100] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TTVEHI__CO_USUA___2EF0D041] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTVEHI__FE_USUA___2FE4F47A] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TTVEHI__CO_USUA___30D918B3] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTVEHI__FE_USUA___31CD3CEC] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTVEHI] WITH NOCHECK ADD CONSTRAINT [CK__TTVEHI__NU_ANNO___2DFCAC08] CHECK NOT FOR REPLICATION (([NU_ANNO_VEHI]>(1980)))
GO
ALTER TABLE [dbo].[TTVEHI] ADD CONSTRAINT [PK__TTVEHI__11C55F4F57A8CD11] PRIMARY KEY CLUSTERED  ([CO_EMPR], [NU_PLAC]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTVEHI] ADD CONSTRAINT [FK__TTVEHI__CO_EMPR__022916C2] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
